Copyright: Copyright © 1997, by Global Constructs.  All Rights Reserved.


Introduction

Visual Basic probably more than any other programming language has benefitted from tools which provide automation of tedious and/or repetitive tasks.  Such tools as Form designers and database access tools permit quick and accurate product development, while maintaining continuity between programs and versions.

The Database Code Builder follows this approach as well by providing a quick and accurate method of generating source code necessary toward creating a database.  Such an approach has the following advantages.

 	The database itself does not require to be distributed with the product but may be created upon usage, thus reducing distribution size.

 	Database design and testing may be performed in a utility such as MS Access, then afterwards creating the necessary source code quickly with the Database Code Builder.

 	Redesign of the database may be performed quickly with automatic source code creation of the new design.


Licensing

Database Code Builder

Version 1.07

Copyright © 1997, by Global Constructs.  All Rights Reserved.

THIS SOFTWARE IS PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.  GLOBAL CONSTRUCTS DOES NOT WARRANT THAT THE FUNCTIONS CONTAINED IN THE SOFTWARE WILL BE UNINTERRUPTED OR ERROR-FREE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH LICENSEE.

IN NO EVENT WILL GLOBAL CONSTRUCTS BE LIABLE TO LICENSEE OR ANY THIRD PARTY FOR ANY DAMAGES INCLUDING ANY LOST PROFITS, LOST SAVINGS OR OTHER INCIDENTAL, CONSEQUENTIAL OR SPECIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PRODUCT EVEN IF GLOBAL CONSTRUCTS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

By using the software, the licensee agrees to abide by the copyright law and all other applicable laws of the US, including but not limited to, export control laws, and the terms of this license. Global Constructs shall have the right to terminate this license immediately by written notice upon the licensee's breach of, or non-compliance with, any of its terms. The licensee may be held legally responsible for any copyright infringement that is caused or encouraged by the licensee's failure to abide by the terms of this license.

This product is Copyright and not in the Public Domain. It may be distributed in its entirety, at a reasonable cost for the medium only. You are permitted 25 trial uses of the product before you are required to register or uninstall the product.  Please support the program by becoming a registered user.  The help file was created with RTFGEN by L. David Baldwin.

The source code developed with the trial version of the Database Code Builder is for demonstration purposes only and may not be used in any distributed product without the express written permission of Global Constructs.  Registered users are granted a personal, non-exclusive license to use or make copies of the software, and then solely for backup or archival purposes.  Registered users may use the source code generated by the Database Code Builder within products for their own personal use.  Registered users must purchase a Royalty Free distribution license for development of products that will be distributed for profit or for other purposes, or goes beyond the control of the registered user.

Disclaimer

Information in this document is subject to change without notice.  Companies, names, and data used as examples (other than those standard to the machine used for the manual's development) are fictitious.  This document may not be reproduced, except for a copy for your individual use, in any manner whatsoever without the express written permission of Global Constructs.  Microsoft, Access, Windows, Windows 95, and Windows NT are trademarks or registered trademarks of Microsoft Corporation.  Other trademarks, trade names, service marks, or service names belong to their respective companies.  Global Constructs denies any proprietary interest in trademarks and trade names other than its own.


Layout

Select a database from which to build a souce code module.  Click any control to get more information.


Order Form
ORDER.TXT                      Global Constructs                     (DCB107)

Database Code Builder Product Order Form

Bill To:                                 Ship To: (if different)

Name     ________________________        Name     ________________________

Company  ________________________        Company  ________________________

Address  ________________________        Address  ________________________

City/                                    City/

Province ________________________        Province ________________________

State    ____________  Zip _______       State    ____________  Zip _______

Country  ________________________        Country  ________________________

Phone    ________________________        Phone    ________________________

Fax      ________________________        Fax      ________________________

Email    ________________________        Email    ________________________

Where did you hear about or obtain the Shareware version of the Database Code Builder?

( ) Internet - Web Page or FTP site: ____________________________

( ) CompuServe

( ) BBS - Name and Phone Number: ____________________________

( ) Other - please specify: ____________________________

Comments: ____________________________

Order Information

Description                           Quantity       Price        Total

Database Code Builder (single copy)   ________   x   $49.00    ________

Database Code Builder with Royalty

Free Distribution of Source Code

Created by Product (single copy)      ________   x   $99.00    ________

Subtotal    ________

TX residents add Sales Tax    ________

Shipping and handling (see below)    ________

Total    ________

Shipping and Handling

US..........$3.50        Canada/Mexico.....$5.00      International.....$8.50

Site license orders please call or email for licensing information.  We accept Purchase Orders from Qualifying Companies only.

Payments must be with check or money order in US Funds drawn on a US Bank.

Make checks payable to:  Global Constructs

Mail to:  Global Constructs

P.O. Box 200305

Arlington, TX 76006 USA


Technical Support

Technical support is provided by email and standard mail.  For standard mail, please provide a SASE for your reply.

For non-registered users, technical support is provided for only installation questions, suggestions, and reporting bugs.

You may contact us at the following address.

Global Constructs

P.O. Box 200305

Arlington, TX 76006

(817) 275-5114

support@globalconstructs.com


Version History

v1.00 Initial Release

This is the first release of the product.

v1.05 Second Release

Attached (linked) tables supported by DBCodeBuilder.

v1.07 Third Release

Common code can be excluded in build.

The last used save path is remembered with the last used data path.


Limitations

The following objects are not recreated in source code from the opened database.  These objects may be added manually to the source code that is created by the Database Code Builder.

 	ODBC tables are identified but not reproduced.

 	Custom Properties, typically made for Databases, Tables, Indexes, and Fields with the CreateProperty Method.

 	Query definitions.

 	User and Group permissions.

 	Replicable property.

 	Customized Containers or Document Objects.

The following are known restrictions or limitations at this time.

 	Only Jet and MS Access databases are supported at this time.

 	MS Access databases may be created in source code but Access specific features such as Forms and Reports are not supported.

 	The source code will create a database for the default version, typically 3.0 (dbVersion30).

 	A module may not be appended to, only overwritten.

Non-registered users are limited to 25 trial uses of the product.  Each startup of the product counts as one use.


Features;contents;encryption;comment level
List of Features

 	MS Access and Jet Databases supported.

 	Creates source code compatible with VB4 and VB5, Professional and Enterprise Editions.

 	Automatic source code creation for the database, including Relationships, Tables, Indexes, and Fields.

 	Low or high levels of commenting within the produced code are available.

 	Selectable database filename or full path reproduced in code.

 	An encrypted or non-encrypted database may be created.

 	Full path control for the source of the database and the save path of the module.

 	Complete help system with available technical support (limited for non-registered users).

 	Complete error checking in all produced source code.

 	Supports attached (linked), hidden, and normal tables.

 	Supports special properties such as Validation Rules and Text and Default Values for Fields, Primary and multiple Field Indexes, and Referential Integrity and Cascadable Updates and Deletes for Relationships.

 	Common code can be excluded when creating multiple files which are to be appended together.


Source Code Module Name

The name of the source code module to be created is entered in this field.  Do not include a path or an extension at this time.

The default module name is DBCreate.


Database Contents List

Upon opening a database, its contents of Tables and Relations are listed in this space.  Tables are identified as normal, hidden, attached, or ODBC.  System Tables are not included in this listing.


Comment Level in Source Code

A commenting level of low or high may be selected prior to building the module.  A high level of commenting includes additional information for each function as well as more involved sections of code.

The default level of commenting is Low.


Code Full Path of Database

The full path name of the opened database may be included (hard coded) into the source code.

The default setting includes only the filename and its extension.


Encrypt the Created Database

A database is not automatically identified as encrypted when opened.  This selection will permit you to create an encrypted database.

By default, an encrypted database is created.


Open a Database

The module to be created requires a database to first be selected by opening it.  The layout of the open database may be viewed in the Database Contents List.


Build the Module

With the selection of Build, a Save As window will open to allow you to select the save path, at which time the Database Code Builder will begin creating the named module.  If the file already exists you will be prompted to continue, stop, or cancel the operation.  Note that while you may type in a different module name in the Save As dialog window, the module will only be created with the name identified above.

By default, this button is disabled until a database is selected by being opened.


Register the Product

A registration name and number may be entered in the available spaces provided in the opening window.  If the product has already been registered, that name and number will be shown.

Without registering, this product is limited to 25 trial uses.


Close the Database Code Builder

Selecting this button will close the program.

Closing this product will complete one use of the 25 trial uses provided to non-registered users.


Add Common Code
Add Common Source Code To Module

Select this option to include the code common to multiple builds.  This permits many Create Database functions to be placed in the same module to reduce code size.

By default, common source code is added.